package vip.xiaonuo.smzq.modular.psba.mapper;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import vip.xiaonuo.smzq.modular.psba.entity.PsbaGtZycl;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

/**
 * 评审备案—资源储量 Mapper
 *
 * @author sqq
 * @since 2024-05-22
 */
@Mapper
public interface PsbaGtZyclMapper extends BaseMapper<PsbaGtZycl> {
     @Select("select kcdm from psba_gt_zycl where psbabh=#{psbabh} group by kcdm")
    List<Integer> getKcdmList(String psbabh);
    @Select("SELECT CONCAT(kslx, ',', kspj, ',', kcdm) AS kslxpj FROM psba_gt_zycl where psbabh=#{psbabh} GROUP BY kslxpj ")
    List<String> getKslxpjList(String psbabh);
    @Select("SELECT zycllx FROM psba_gt_zycl where psbabh=#{psbabh} and kslx=#{kslx} and kspj=#{kspj} and kcdm=#{kcdm} GROUP BY zycllx ")
    List<String> getZycllzList(@Param("psbabh") String psbabh, @Param("kslx") Integer kslx, @Param("kspj") Integer kspj,@Param("kcdm") Integer kcdm);
}
